<?php
$host = 'localhost';
$user = 'root';
$pass = '';
$db = 'tblNavagite';
$tblname ='tblchat';
$con = mysqli_connect($host,$user,$pass,$db)or die(mysqli_error($con));
$limit = 10;	// show 10 records
if((isset($_GET['next']))){
	$n = $_GET['next']+10;
	$page_str = "SELECT * FROM $tblname LIMIT $n,$limit";
}
else{
	$n = 10;
	$page_str = "SELECT * FROM $tblname LIMIT 0,$limit";
}

if(isset($_GET['next'])){
	$p = $_GET['next'] -10;
}
if(isset($_GET['prev'])){
	$p = $_GET['prev'] - 10;
	$page_str = "SELECT * FROM $tblname LIMIT $p,$limit";
}

$page_query = mysqli_query($con,$page_str)or die(mysql_error($con));

if((isset($_GET['next']) && $_GET['next']>10) || (isset($_GET['prev']) && $_GET['prev']>10)){
echo "<a href='?prev=$p'> Prev </a>";
}
if(mysqli_num_rows($page_query)>=10){
echo "| <a href='?next=$n'>Next</a> | ";
}

echo "<br />";
while($page_result = mysqli_fetch_assoc($page_query)){
	echo "$page_result[id] = $page_result[col1] : $page_result[date]<br />";
}
?>
</p>
